An aggregate-disaggregate intermittent demand approach (ADIDA) to forecasting: an empirical proposition and analysis

Intermittent demand patterns are characterised by infrequent demand arrivals coupled with variable demand sizes. Such patterns prevail in many industrial applications, including IT, automotive, aerospace and military. An intuitively appealing strategy to deal with such patterns from a forecasting perspective is to aggregate demand in lower-frequency ‘time buckets’ thereby reducing the presence of zero observations. However, such aggregation may result in losing useful information, as the frequency of observations is reduced. In this paper, we explore the effects of aggregation by investigating 5,000 Stock Keeping Units (SKUs) from the Royal Air Force (RAF, UK). We are also concerned with the empirical determination of an optimum aggregation level as well as the effects of aggregating demand in time buckets that equal the lead time length (plus review period). This part of the analysis is of direct relevance to a (periodic) inventory management setting where such cumulative lead-time demand estimates are required. Our study allows insights to be gained into the value of aggregation in an intermittent demand context. The paper concludes with an agenda for further research in this area.